home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Dr. Windows 3
/
dr win3.zip
/
dr win3
/
DATABASE
/
FOXRYAN.ZIP
/
VERIFY7.PRG
< prev
next >
Wrap
Text File
|
1993-07-20
|
1KB
|
44 lines
╓─FOR m.i = 1 TO 22
║ m.form = "form" + ALLTRIM(STR(m.i))
║ m.dbfile = m.form + ".dbf"
║ *;if m.i = 3 or m.i = 11
║ *; m.qn = -1
║ *;else
║ m.qn = -2
║ *;endif
║ ╓─FOR m.j = 0 TO 7
║ ║ m.letter = IIF(m.j = 0, "", CHR(m.j-1+ASC("A")))
║ ║ m.rptfile = m.form + ALLTRIM(m.letter) + ".frx"
║ ║ ?m.rptfile
║ ║ SELECT 0
║ ║ ┌─IF NOT FILE(m.rptfile)
║ v═══════EXIT
║ ║ └─ENDIF
║ ║ USE &rptfile ALIAS REPORT
║ ║ GO TOP
║ ║ LOCATE FOR report.objtype=8
║ ║ ╔═DO WHILE NOT EOF()
║ ║ ║ ┌─IF INKEY()=27
║ ║ ║ │ SUSPEND
║ ║ ║ └─ENDIF
║ ║ ║ m.expr = report.expr
║ ║ ║ ╒═DO CASE
║ ║ ║ ╞═CASE m.qn = -2
║ ║ ║ │ m.expr = m.form + ".today"
║ ║ ║ ╞═CASE m.qn = -1
║ ║ ║ │ m.expr = m.form + ".facility"
║ ║ ║ ╞═CASE m.qn = 0
║ ║ ║ │ m.expr = m.form + ".passzone"
║ ║ ║ ╞═OTHERWISE
║ ║ ║ │ m.qt = m.form + '.q' + ALLTRIM(STR(m.qn))
║ ║ ║ │ m.expr = 'iif(' + m.qt + '=1, "X", "O") + " Yes " + iif(' + m.qt + '=2, "X", "O") + " No " + iif(' + m.qt + '=3, "X", "O") + " N/A"'
║ ║ ║ ╘═ENDCASE
║ ║ ║ REPLACE report.expr WITH m.expr
║ ║ ║ m.qn = m.qn + 1
║ ║ ║ CONTINUE
║ ║ ╚═ENDDO
║ ║ USE
║ ╙─ENDFOR
╙─ENDFOR